package com.buer.storage.dao;



import com.buer.storage.dto.SelectStockDto;
import com.buer.storage.entity.Area;
import com.buer.storage.entity.Stock;
import com.buer.storage.vo.StockVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * 装备库存表
 * @date 2021-01-21 21:24:06
 */
@Mapper
public interface StockDao {

	Stock get(Integer stockId);
	
	List<Stock> list(Map<String,Object> map);

	List<StockVo> getAllStock();
	
	int count(Map<String,Object> map);
	
	int save(Stock stock);
	
	int update(Stock stock);
	
	int remove(Integer stock_id);
	
	int batchRemove(Integer[] stockIds);

    List<Stock> getStockList(Map<String, Object> map);

	Stock getOne(Map<String, Object> map);

	List<SelectStockDto> selectStockNumSum();

	int selectWorderProdNum(String putDate);

	int selectDorderProdNum(String outDate);

	List<Area> selectAreaName();

	int selectDorderNumByName(@Param("areaId") Integer areaId, @Param("outDate") String outDate);

	int selectWorderNumByName(@Param("areaId") Integer areaId,@Param("putDate") String putDate);


}
